SUPPORT / SAMPLES & SAS NOTES
Problem Note 55906: Appending multiple records to a table using ViewData in SAS® Data Integration Studio fails with the error "Not positioned on a valid row"
 |  |  |  |
When you update a table using ViewData in SAS Data Integration Studio, you might receive an error message similar to the following:
Not positioned on a valid row.
The error occurs after you have successfully added one record to the table and then attempt to add an additional record. If you close the table and open it again, you see that the new records have been added to the table. However, a duplicate record has also been added for each new record added.
There is no workaround.
The problem has been fixed in SAS® 9.4 M3.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Windows 7 Professional x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 Std | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 4.7 | 4.901 | 9.4 TS1M0 | 9.4 TS1M3 | ||